package com.example.lvsuo.mapper;

import com.example.lvsuo.entity.HrEmp;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.lvsuo.entity.HrWorkhistory;
import com.example.lvsuo.entity.vo.HrEmpVo;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author 心心念念
 * @since 2021-03-30
 */
@Mapper
public interface HrEmpMapper extends BaseMapper<HrEmp> {
    List<HrEmpVo> getHrEmp(HrEmpVo hrEmpVo);

    void deleteHrEmp(Integer id);

    void updateHrEmp(HrEmp hrEmp);

    List<HrEmp> getWorkByid(String id);

    @Select(" select * from hr_emp where emp_name=#{value} ")
    List<HrEmp> getHrEmpByName(String empName);

    @Select(" select * from hr_emp where emp_workstatus = 'Y' ")
    List<HrEmp> queryhrEmpService();
}
